package com.vq3.digitalizationsoftwareintegrates.Mapper.User;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.vq3.digitalizationsoftwareintegrates.Entity.User.UserEntity;
import com.vq3.digitalizationsoftwareintegrates.Entity.User.User_RoleEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**用户的mapper类
 * */
@Mapper
@DS("db01")
public interface UserMapper extends BaseMapper<UserEntity> {
    @Select("select current_date;")
    String getDate();
    @Select("select current_time;")
    String getTime();

    @Select("select * from user where uid=#{uid} limit #{start},#{size}")
    List<User_RoleEntity> uidFindUser(@Param("uid") int uid, @Param("start") int start, @Param("size") int size);


}
